Excel Data Cleansing Straight to the Point by Oz du Soleil;

Author:Oz du Soleil;
Language: eng
Format: epub
Tags: Excel;Excel on Fire; Power Query; MATCH function; Text to Columns;
Publisher: Independent Publishers Group
Published: 2019-07-16T00:00:00+00:00

To properly train Flash Fill, you can press Esc and type in CHUCK and HARRIET, as shown below.

Next, highlight the entire column where you want the final names to appear and choose Data > Data Tools > Flash Fill.

As you can see below, this does the trick, and you get exactly what you wanted!

Splitting by a Single Delimiter: Separating the City from the Name

Now, using the same data as for the nametag example, say that you need to separate the names from the cities. This would be easy enough to do with Flash Fill, but what if you’ll be adding more data to the list and need to repeat the parsing of the names from the cities? Two words: Power Query!

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.